Add column

When you add a column to multiple tables, you must provide a name, define the data type for the column and define the data that the column contains. The column that you define here is added to all tables that fit the definition you created in step Transformation scope.

The following describes the information you must enter in the transformation rule page for adding a column.

• Column name: Click the [string] to activate the field. Type the name for the column in the field. A column with this name is added to all tables that fit the definition you created in step Transformation scope.

• Add to Primary Key: Select to add the column to the target tables' Primary Key.

• Expression: Click the button to the right of this field to open the Expression Builder or type an expression using SQLite operators to define the data in the column.

  For information on how to use the Expression Editor to create an expression, see Using the Expression Builder.

  For more information on creating expressions, see Creating an expression for transformations and Using SQLite syntax with transformations.

• Set target data type to: Click the drop-down for a list of data types and select a new data type from the drop-down list. Make sure that the data type you select is compatible with the data in that column. When BYTES, STRING or WSTRING is selected, specify a Length as well. When NUMERIC is selected, specify a Precision and Scale as well.

• Subtype: When CLOB, NCLOB, STRING, or WSTRING data types are selected, you can also set a data subtype. Select either JSON or XML from the Subtype drop-down list. Make sure that the data in the new column will be compatible with the selected subtype. The default is Regular, which means that the regular data type will be used without a subtype.

   

  For a description of available data types, see Replicate data types. For information about data type mapping from the native endpoint to Qlik Replicate data types, see the section for the endpoint you use. For a list of supported databases, see Supported Platforms and Endpoints.